package com.fh.modules.dbms.entity;

import java.io.Serializable;
import java.util.Date;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
import org.jeecgframework.poi.excel.annotation.Excel;

import com.fh.common.query.QueryRuleEnum;
import com.fh.common.query.annotation.QueryWrapperRule;

/**
 * @Description: 数据源管理
 * @author： code generator
 * @date：   2020-05-15
 * @version： V1.0
 */
@Data
@TableName("dbms_dbsource")
public class DbmsDbsource implements Serializable {
    private static final long serialVersionUID = 1L;
    
	/**主键*/
	@TableId(type = IdType.AUTO)
	private Integer id;
	/**数据源名称*/
	@Excel(name = "数据源名称", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String sourceName;
	/**数据库类型ID*/
	@Excel(name = "数据库类型ID", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private Integer typeId;
	/**用户名称*/
	@Excel(name = "用户名", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String userName;
	/**密码*/
	@Excel(name = "密码", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String password;
	/**ip地址*/
	@Excel(name = "ip地址", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String ip;
	/**端口*/
	@Excel(name = "端口", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String port;
	/**数据库名*/
	@Excel(name = "数据库名", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String dbName;
	/**URL地址*/
	@Excel(name = "URL地址", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String url;
	/**url请求后缀*/
	@Excel(name = "url请求后缀", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String urlSuffix;
	/**0不可用，1正常，2无法连接*/
	@Excel(name = "0不可用，1正常，2无法连接", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private Integer status;
	/**删除状态（0，正常，1已删除）*/
	@Excel(name = "删除状态（0，正常，1已删除）", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private Integer delFlag;
	/**创建人*/
	@Excel(name = "创建人", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String createBy;
	/**创建时间*/
	@Excel(name = "创建时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
	private Date createTime;
	/**更新人*/
	@Excel(name = "更新人", width = 15)
	@QueryWrapperRule(rule=QueryRuleEnum.EQ)
	private String updateBy;
	/**更新时间*/
	@Excel(name = "更新时间", width = 20, format = "yyyy-MM-dd HH:mm:ss")
	@JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
    @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
	private Date updateTime;
}
